explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uyVW

Settings
# exclusive inclusive rows x rows loops node
1. 0.039 46.695 ↑ 1.0 100 1

Limit (cost=0.72..699.17 rows=100 width=1,199) (actual time=0.140..46.695 rows=100 loops=1)

  • Buffers: shared hit=71974
2. 4.606 46.656 ↑ 47.1 100 1

Nested Loop (cost=0.72..32,890.48 rows=4,709 width=1,199) (actual time=0.138..46.656 rows=100 loops=1)

  • Buffers: shared hit=71974
3. 2.202 6.202 ↑ 1.5 17,924 1

Append (cost=0.29..839.25 rows=27,398 width=16) (actual time=0.052..6.202 rows=17,924 loops=1)

  • Buffers: shared hit=182
4. 4.000 4.000 ↑ 1.5 17,924 1

Index Scan using _hyper_5_1660_chunk_facteventflow_id_event_time_idx on _hyper_5_1660_chunk ff (cost=0.29..839.25 rows=27,398 width=16) (actual time=0.050..4.000 rows=17,924 loops=1)

  • Index Cond: ((event_time > '2018-09-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-10-15 00:00:00+00'::timestamp with time zone))
  • Buffers: shared hit=182
5. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_5_1659_chunk_facteventflow_id_event_time_idx on _hyper_5_1659_chunk ff_1 (cost=0.29..839.23 rows=27,397 width=16) (never executed)

  • Index Cond: ((event_time > '2018-09-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-10-15 00:00:00+00'::timestamp with time zone))
6. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_5_1658_chunk_facteventflow_id_event_time_idx on _hyper_5_1658_chunk ff_2 (cost=0.29..839.23 rows=27,397 width=16) (never executed)

  • Index Cond: ((event_time > '2018-09-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-10-15 00:00:00+00'::timestamp with time zone))
7. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_5_1657_chunk_facteventflow_id_event_time_idx on _hyper_5_1657_chunk ff_3 (cost=0.29..839.23 rows=27,397 width=16) (never executed)

  • Index Cond: ((event_time > '2018-09-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-10-15 00:00:00+00'::timestamp with time zone))
8. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_5_1656_chunk_facteventflow_id_event_time_idx on _hyper_5_1656_chunk ff_4 (cost=0.29..839.25 rows=27,398 width=16) (never executed)

  • Index Cond: ((event_time > '2018-09-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-10-15 00:00:00+00'::timestamp with time zone))
9. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_5_1655_chunk_facteventflow_id_event_time_idx on _hyper_5_1655_chunk ff_5 (cost=0.29..839.23 rows=27,397 width=16) (never executed)

  • Index Cond: ((event_time > '2018-09-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-10-15 00:00:00+00'::timestamp with time zone))
10. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_5_1654_chunk_facteventflow_id_event_time_idx on _hyper_5_1654_chunk ff_6 (cost=0.29..839.23 rows=27,397 width=16) (never executed)

  • Index Cond: ((event_time > '2018-09-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-10-15 00:00:00+00'::timestamp with time zone))
11. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_5_1653_chunk_facteventflow_id_event_time_idx on _hyper_5_1653_chunk ff_7 (cost=0.29..839.25 rows=27,398 width=16) (never executed)

  • Index Cond: ((event_time > '2018-09-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-10-15 00:00:00+00'::timestamp with time zone))
12. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_5_1652_chunk_facteventflow_id_event_time_idx on _hyper_5_1652_chunk ff_8 (cost=0.29..839.23 rows=27,397 width=16) (never executed)

  • Index Cond: ((event_time > '2018-09-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-10-15 00:00:00+00'::timestamp with time zone))
13. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_5_1651_chunk_facteventflow_id_event_time_idx on _hyper_5_1651_chunk ff_9 (cost=0.29..839.23 rows=27,397 width=16) (never executed)

  • Index Cond: ((event_time > '2018-09-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-10-15 00:00:00+00'::timestamp with time zone))
14. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_5_1650_chunk_facteventflow_id_event_time_idx on _hyper_5_1650_chunk ff_10 (cost=0.29..839.23 rows=27,397 width=16) (never executed)

  • Index Cond: ((event_time > '2018-09-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-10-15 00:00:00+00'::timestamp with time zone))
15. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_5_1649_chunk_facteventflow_id_event_time_idx on _hyper_5_1649_chunk ff_11 (cost=0.29..839.25 rows=27,398 width=16) (never executed)

  • Index Cond: ((event_time > '2018-09-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-10-15 00:00:00+00'::timestamp with time zone))
16. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_5_1648_chunk_facteventflow_id_event_time_idx on _hyper_5_1648_chunk ff_12 (cost=0.29..839.23 rows=27,397 width=16) (never executed)

  • Index Cond: ((event_time > '2018-09-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-10-15 00:00:00+00'::timestamp with time zone))
17. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_5_1647_chunk_facteventflow_id_event_time_idx on _hyper_5_1647_chunk ff_13 (cost=0.29..839.23 rows=27,397 width=16) (never executed)

  • Index Cond: ((event_time > '2018-09-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-10-15 00:00:00+00'::timestamp with time zone))
18. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_5_1646_chunk_facteventflow_id_event_time_idx on _hyper_5_1646_chunk ff_14 (cost=0.29..839.23 rows=27,397 width=16) (never executed)

  • Index Cond: ((event_time > '2018-09-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-10-15 00:00:00+00'::timestamp with time zone))
19. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_5_1645_chunk_facteventflow_id_event_time_idx on _hyper_5_1645_chunk ff_15 (cost=0.29..839.25 rows=27,398 width=16) (never executed)

  • Index Cond: ((event_time > '2018-09-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-10-15 00:00:00+00'::timestamp with time zone))
20. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_5_1644_chunk_facteventflow_id_event_time_idx on _hyper_5_1644_chunk ff_16 (cost=0.29..839.23 rows=27,397 width=16) (never executed)

  • Index Cond: ((event_time > '2018-09-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-10-15 00:00:00+00'::timestamp with time zone))
21. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_5_1643_chunk_facteventflow_id_event_time_idx on _hyper_5_1643_chunk ff_17 (cost=0.29..839.23 rows=27,397 width=16) (never executed)

  • Index Cond: ((event_time > '2018-09-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-10-15 00:00:00+00'::timestamp with time zone))
22. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_5_1642_chunk_facteventflow_id_event_time_idx on _hyper_5_1642_chunk ff_18 (cost=0.29..839.23 rows=27,397 width=16) (never executed)

  • Index Cond: ((event_time > '2018-09-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-10-15 00:00:00+00'::timestamp with time zone))
23. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_5_1641_chunk_facteventflow_id_event_time_idx on _hyper_5_1641_chunk ff_19 (cost=0.29..839.25 rows=27,398 width=16) (never executed)

  • Index Cond: ((event_time > '2018-09-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-10-15 00:00:00+00'::timestamp with time zone))
24. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_5_1640_chunk_facteventflow_id_event_time_idx on _hyper_5_1640_chunk ff_20 (cost=0.29..839.23 rows=27,397 width=16) (never executed)

  • Index Cond: ((event_time > '2018-09-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-10-15 00:00:00+00'::timestamp with time zone))
25. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_5_1639_chunk_facteventflow_id_event_time_idx on _hyper_5_1639_chunk ff_21 (cost=0.29..839.23 rows=27,397 width=16) (never executed)

  • Index Cond: ((event_time > '2018-09-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-10-15 00:00:00+00'::timestamp with time zone))
26. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_5_1638_chunk_facteventflow_id_event_time_idx on _hyper_5_1638_chunk ff_22 (cost=0.29..839.23 rows=27,397 width=16) (never executed)

  • Index Cond: ((event_time > '2018-09-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-10-15 00:00:00+00'::timestamp with time zone))
27. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_5_1637_chunk_facteventflow_id_event_time_idx on _hyper_5_1637_chunk ff_23 (cost=0.29..839.25 rows=27,398 width=16) (never executed)

  • Index Cond: ((event_time > '2018-09-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-10-15 00:00:00+00'::timestamp with time zone))
28. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_5_1636_chunk_facteventflow_id_event_time_idx on _hyper_5_1636_chunk ff_24 (cost=0.29..839.23 rows=27,397 width=16) (never executed)

  • Index Cond: ((event_time > '2018-09-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-10-15 00:00:00+00'::timestamp with time zone))
29. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_5_1635_chunk_facteventflow_id_event_time_idx on _hyper_5_1635_chunk ff_25 (cost=0.29..839.23 rows=27,397 width=16) (never executed)

  • Index Cond: ((event_time > '2018-09-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-10-15 00:00:00+00'::timestamp with time zone))
30. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_5_1634_chunk_facteventflow_id_event_time_idx on _hyper_5_1634_chunk ff_26 (cost=0.29..839.23 rows=27,397 width=16) (never executed)

  • Index Cond: ((event_time > '2018-09-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-10-15 00:00:00+00'::timestamp with time zone))
31. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_5_1633_chunk_facteventflow_id_event_time_idx on _hyper_5_1633_chunk ff_27 (cost=0.29..839.25 rows=27,398 width=16) (never executed)

  • Index Cond: ((event_time > '2018-09-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-10-15 00:00:00+00'::timestamp with time zone))
32. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_5_1632_chunk_facteventflow_id_event_time_idx on _hyper_5_1632_chunk ff_28 (cost=0.29..839.23 rows=27,397 width=16) (never executed)

  • Index Cond: ((event_time > '2018-09-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-10-15 00:00:00+00'::timestamp with time zone))
33. 0.000 0.000 ↓ 0.0 0

Index Scan using _hyper_5_1631_chunk_facteventflow_id_event_time_idx on _hyper_5_1631_chunk ff_29 (cost=0.29..839.23 rows=27,397 width=16) (never executed)

  • Index Cond: ((event_time > '2018-09-15 00:00:00+00'::timestamp with time zone) AND (event_time < '2018-10-15 00:00:00+00'::timestamp with time zone))
34. 35.848 35.848 ↓ 0.0 0 17,924

Index Scan using facteventflow_tag_pkey on facteventflow_tag fft (cost=0.43..1.17 rows=1 width=1,183) (actual time=0.002..0.002 rows=0 loops=17,924)

  • Index Cond: (fact_id = ff.fact_id)
  • Filter: ((app_type = ANY ('{1,2,3,4,5}'::integer[])) AND (target_id = ANY ('{1,2,3,4,5,6,7,8,9,10}'::integer[])))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=71792