explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ruEz

Settings
# exclusive inclusive rows x rows loops node
1. 4.536 248.846 ↑ 1.0 25 1

Limit (cost=22,257.45..22,257.51 rows=25 width=197) (actual time=244.310..248.846 rows=25 loops=1)

2. 0.127 244.310 ↑ 3.0 25 1

Sort (cost=22,257.45..22,257.63 rows=75 width=197) (actual time=244.308..244.310 rows=25 loops=1)

  • Sort Key: entity1_.name DESC
  • Sort Method: quicksort Memory: 36kB
3. 0.242 244.183 ↑ 1.7 43 1

GroupAggregate (cost=22,239.77..22,255.33 rows=75 width=197) (actual time=243.978..244.183 rows=43 loops=1)

  • Group Key: entityaggr0_.entity_id, entity1_.name, entityaggr0_.fuel_type
4. 0.192 243.941 ↑ 1.7 43 1

Sort (cost=22,239.77..22,239.95 rows=75 width=141) (actual time=243.935..243.941 rows=43 loops=1)

  • Sort Key: entityaggr0_.entity_id, entity1_.name DESC, entityaggr0_.fuel_type
  • Sort Method: quicksort Memory: 36kB
5. 0.294 243.749 ↑ 1.7 43 1

Nested Loop (cost=18,798.22..22,237.43 rows=75 width=141) (actual time=241.044..243.749 rows=43 loops=1)

6. 0.118 241.907 ↑ 1.3 43 1

Nested Loop (cost=18,797.79..19,099.93 rows=56 width=27) (actual time=241.000..241.907 rows=43 loops=1)

7. 0.069 240.886 ↑ 1.3 43 1

HashAggregate (cost=18,797.37..18,797.93 rows=56 width=8) (actual time=240.837..240.886 rows=43 loops=1)

  • Group Key: entityaggr3_.entity_id
8. 0.018 240.817 ↑ 1.3 43 1

Group (cost=18,796.25..18,796.67 rows=56 width=10) (actual time=240.797..240.817 rows=43 loops=1)

  • Group Key: entityaggr3_.entity_id, entityaggr3_.fuel_type
9. 0.091 240.799 ↑ 1.3 43 1

Sort (cost=18,796.25..18,796.39 rows=56 width=10) (actual time=240.794..240.799 rows=43 loops=1)

  • Sort Key: entityaggr3_.entity_id, entityaggr3_.fuel_type
  • Sort Method: quicksort Memory: 27kB
10. 0.000 240.708 ↑ 1.3 43 1

Nested Loop (cost=1,001.43..18,794.62 rows=56 width=10) (actual time=21.694..240.708 rows=43 loops=1)

11. 0.006 0.200 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.57..5.62 rows=1 width=4) (actual time=0.188..0.200 rows=1 loops=1)

  • Join Filter: (partner6_.id = partner6_1_.child_id)
12. 0.121 0.121 ↑ 1.0 1 1

Index Only Scan using pk_partner on partner partner6_ (cost=0.29..2.80 rows=1 width=4) (actual time=0.117..0.121 rows=1 loops=1)

  • Index Cond: (id = 10,002)
  • Heap Fetches: 0
13. 0.073 0.073 ↑ 1.0 1 1

Index Only Scan using partner_tree_pkey on partner_tree partner6_1_ (cost=0.29..2.80 rows=1 width=8) (actual time=0.066..0.073 rows=1 loops=1)

  • Index Cond: (child_id = 10,002)
  • Heap Fetches: 0
14. 32.739 244.996 ↑ 1.3 43 1

Gather (cost=1,000.86..18,788.44 rows=56 width=14) (actual time=21.503..244.996 rows=43 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
15. 0.125 212.257 ↑ 1.6 14 3 / 3

Nested Loop (cost=0.86..17,782.84 rows=23 width=14) (actual time=22.403..212.257 rows=14 loops=3)

  • Join Filter: (entity4_.id = entityaggr3_.entity_id)
16. 1.540 98.207 ↑ 2.5 15 3 / 3

Nested Loop (cost=0.42..14,738.13 rows=37 width=12) (actual time=22.221..98.207 rows=15 loops=3)

17. 87.033 87.033 ↓ 1.5 1,376 3 / 3

Parallel Seq Scan on entity entity4_ (cost=0.00..12,593.21 rows=892 width=4) (actual time=0.741..87.033 rows=1,376 loops=3)

  • Filter: ((activated_module_array IS NOT NULL) AND (entity_type_id <> 2) AND (integration_status_id >= 4) AND (integration_status_id <> '-2'::integer) AND ((activated_module_array IS NULL) OR ((activated_module_array)::text ~~* '%[3%'::text) OR ((activated_module_array)::text ~~* '%,3%'::text) OR ((activated_module_array)::text ~~* '%3,%'::text) OR ((activated_module_array)::text ~~* '%3]%'::text)))
  • Rows Removed by Filter: 72,873
18. 9.634 9.634 ↓ 0.0 0 4,129 / 3

Index Only Scan using pk_entity_partner on entity_partner partners5_ (cost=0.42..2.40 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=4,129)

  • Index Cond: ((entity_id = entity4_.id) AND (partner_id = 10,002))
  • Heap Fetches: 4
19. 0.081 113.925 ↑ 16.0 1 45 / 3

Append (cost=0.43..82.09 rows=16 width=10) (actual time=7.593..7.595 rows=1 loops=45)

20. 3.927 3.927 ↑ 1.0 1 2 / 3

Index Scan using entity_aggregated_data_00_entity_id_date_idx on entity_aggregated_data_00 entityaggr3_ (cost=0.43..5.14 rows=1 width=10) (actual time=5.888..5.890 rows=1 loops=2)

  • Index Cond: ((entity_id = partners5_.entity_id) AND (date >= '2019-03-11 00:00:00'::timestamp without time zone) AND (date < '2019-03-12 00:00:00'::timestamp without time zone))
21. 2.821 2.821 ↑ 1.0 1 1 / 3

Index Scan using entity_aggregated_data_01_entity_id_date_idx on entity_aggregated_data_01 entityaggr3__1 (cost=0.43..5.13 rows=1 width=10) (actual time=8.460..8.462 rows=1 loops=1)

  • Index Cond: ((entity_id = partners5_.entity_id) AND (date >= '2019-03-11 00:00:00'::timestamp without time zone) AND (date < '2019-03-12 00:00:00'::timestamp without time zone))
22. 0.112 0.112 ↑ 1.0 1 5 / 3

Index Scan using entity_aggregated_data_02_entity_id_date_idx on entity_aggregated_data_02 entityaggr3__2 (cost=0.43..5.13 rows=1 width=10) (actual time=0.066..0.067 rows=1 loops=5)

  • Index Cond: ((entity_id = partners5_.entity_id) AND (date >= '2019-03-11 00:00:00'::timestamp without time zone) AND (date < '2019-03-12 00:00:00'::timestamp without time zone))
23. 15.456 15.456 ↑ 1.0 1 6 / 3

Index Scan using entity_aggregated_data_03_entity_id_date_idx on entity_aggregated_data_03 entityaggr3__3 (cost=0.43..5.13 rows=1 width=10) (actual time=7.727..7.728 rows=1 loops=6)

  • Index Cond: ((entity_id = partners5_.entity_id) AND (date >= '2019-03-11 00:00:00'::timestamp without time zone) AND (date < '2019-03-12 00:00:00'::timestamp without time zone))
24. 13.962 13.962 ↑ 1.0 1 2 / 3

Index Scan using entity_aggregated_data_04_entity_id_date_idx on entity_aggregated_data_04 entityaggr3__4 (cost=0.43..5.12 rows=1 width=10) (actual time=20.941..20.943 rows=1 loops=2)

  • Index Cond: ((entity_id = partners5_.entity_id) AND (date >= '2019-03-11 00:00:00'::timestamp without time zone) AND (date < '2019-03-12 00:00:00'::timestamp without time zone))
25. 0.077 0.077 ↑ 1.0 1 1 / 3

Index Scan using entity_aggregated_data_05_entity_id_date_idx on entity_aggregated_data_05 entityaggr3__5 (cost=0.43..5.13 rows=1 width=10) (actual time=0.230..0.232 rows=1 loops=1)

  • Index Cond: ((entity_id = partners5_.entity_id) AND (date >= '2019-03-11 00:00:00'::timestamp without time zone) AND (date < '2019-03-12 00:00:00'::timestamp without time zone))
26. 20.584 20.584 ↑ 1.0 1 6 / 3

Index Scan using entity_aggregated_data_06_entity_id_date_idx on entity_aggregated_data_06 entityaggr3__6 (cost=0.43..5.12 rows=1 width=10) (actual time=10.290..10.292 rows=1 loops=6)

  • Index Cond: ((entity_id = partners5_.entity_id) AND (date >= '2019-03-11 00:00:00'::timestamp without time zone) AND (date < '2019-03-12 00:00:00'::timestamp without time zone))
27. 0.014 0.014 ↓ 0.0 0 1 / 3

Index Scan using entity_aggregated_data_07_entity_id_date_idx on entity_aggregated_data_07 entityaggr3__7 (cost=0.43..5.12 rows=1 width=10) (actual time=0.043..0.043 rows=0 loops=1)

  • Index Cond: ((entity_id = partners5_.entity_id) AND (date >= '2019-03-11 00:00:00'::timestamp without time zone) AND (date < '2019-03-12 00:00:00'::timestamp without time zone))
28. 0.083 0.083 ↑ 1.0 1 1 / 3

Index Scan using entity_aggregated_data_08_entity_id_date_idx on entity_aggregated_data_08 entityaggr3__8 (cost=0.43..5.12 rows=1 width=10) (actual time=0.247..0.249 rows=1 loops=1)

  • Index Cond: ((entity_id = partners5_.entity_id) AND (date >= '2019-03-11 00:00:00'::timestamp without time zone) AND (date < '2019-03-12 00:00:00'::timestamp without time zone))
29. 0.097 0.097 ↑ 1.0 1 3 / 3

Index Scan using entity_aggregated_data_09_entity_id_date_idx on entity_aggregated_data_09 entityaggr3__9 (cost=0.43..5.13 rows=1 width=10) (actual time=0.096..0.097 rows=1 loops=3)

  • Index Cond: ((entity_id = partners5_.entity_id) AND (date >= '2019-03-11 00:00:00'::timestamp without time zone) AND (date < '2019-03-12 00:00:00'::timestamp without time zone))
30. 0.022 0.022 ↑ 1.0 1 1 / 3

Index Scan using entity_aggregated_data_10_entity_id_date_idx on entity_aggregated_data_10 entityaggr3__10 (cost=0.43..5.13 rows=1 width=10) (actual time=0.065..0.066 rows=1 loops=1)

  • Index Cond: ((entity_id = partners5_.entity_id) AND (date >= '2019-03-11 00:00:00'::timestamp without time zone) AND (date < '2019-03-12 00:00:00'::timestamp without time zone))
31. 17.323 17.323 ↑ 1.0 1 3 / 3

Index Scan using entity_aggregated_data_11_entity_id_date_idx on entity_aggregated_data_11 entityaggr3__11 (cost=0.43..5.12 rows=1 width=10) (actual time=17.320..17.323 rows=1 loops=3)

  • Index Cond: ((entity_id = partners5_.entity_id) AND (date >= '2019-03-11 00:00:00'::timestamp without time zone) AND (date < '2019-03-12 00:00:00'::timestamp without time zone))
32. 0.059 0.059 ↑ 1.0 1 3 / 3

Index Scan using entity_aggregated_data_12_entity_id_date_idx on entity_aggregated_data_12 entityaggr3__12 (cost=0.43..5.13 rows=1 width=10) (actual time=0.058..0.059 rows=1 loops=3)

  • Index Cond: ((entity_id = partners5_.entity_id) AND (date >= '2019-03-11 00:00:00'::timestamp without time zone) AND (date < '2019-03-12 00:00:00'::timestamp without time zone))
33. 0.065 0.065 ↑ 1.0 1 2 / 3

Index Scan using entity_aggregated_data_13_entity_id_date_idx on entity_aggregated_data_13 entityaggr3__13 (cost=0.43..5.12 rows=1 width=10) (actual time=0.096..0.097 rows=1 loops=2)

  • Index Cond: ((entity_id = partners5_.entity_id) AND (date >= '2019-03-11 00:00:00'::timestamp without time zone) AND (date < '2019-03-12 00:00:00'::timestamp without time zone))
34. 36.854 36.854 ↑ 1.0 1 3 / 3

Index Scan using entity_aggregated_data_14_entity_id_date_idx on entity_aggregated_data_14 entityaggr3__14 (cost=0.43..5.12 rows=1 width=10) (actual time=36.853..36.854 rows=1 loops=3)

  • Index Cond: ((entity_id = partners5_.entity_id) AND (date >= '2019-03-11 00:00:00'::timestamp without time zone) AND (date < '2019-03-12 00:00:00'::timestamp without time zone))
35. 2.388 2.388 ↑ 1.0 1 5 / 3

Index Scan using entity_aggregated_data_15_entity_id_date_idx on entity_aggregated_data_15 entityaggr3__15 (cost=0.43..5.13 rows=1 width=10) (actual time=1.431..1.433 rows=1 loops=5)

  • Index Cond: ((entity_id = partners5_.entity_id) AND (date >= '2019-03-11 00:00:00'::timestamp without time zone) AND (date < '2019-03-12 00:00:00'::timestamp without time zone))
36. 0.903 0.903 ↑ 1.0 1 43

Index Scan using pk_entity on entity entity1_ (cost=0.42..5.39 rows=1 width=19) (actual time=0.021..0.021 rows=1 loops=43)

  • Index Cond: (id = entityaggr3_.entity_id)
37. 0.236 1.548 ↑ 16.0 1 43

Append (cost=0.43..55.87 rows=16 width=126) (actual time=0.035..0.036 rows=1 loops=43)

38. 0.060 0.060 ↑ 1.0 1 2

Index Scan using entity_aggregated_data_00_entity_id_date_idx on entity_aggregated_data_00 entityaggr0_ (cost=0.43..3.51 rows=1 width=126) (actual time=0.029..0.030 rows=1 loops=2)

  • Index Cond: ((entity_id = entity1_.id) AND (date >= '2019-03-11 00:00:00'::timestamp without time zone) AND (date < '2019-03-12 00:00:00'::timestamp without time zone))
39. 0.030 0.030 ↑ 1.0 1 1

Index Scan using entity_aggregated_data_01_entity_id_date_idx on entity_aggregated_data_01 entityaggr0__1 (cost=0.43..3.49 rows=1 width=126) (actual time=0.030..0.030 rows=1 loops=1)

  • Index Cond: ((entity_id = entity1_.id) AND (date >= '2019-03-11 00:00:00'::timestamp without time zone) AND (date < '2019-03-12 00:00:00'::timestamp without time zone))
40. 0.120 0.120 ↑ 1.0 1 5

Index Scan using entity_aggregated_data_02_entity_id_date_idx on entity_aggregated_data_02 entityaggr0__2 (cost=0.43..3.49 rows=1 width=126) (actual time=0.023..0.024 rows=1 loops=5)

  • Index Cond: ((entity_id = entity1_.id) AND (date >= '2019-03-11 00:00:00'::timestamp without time zone) AND (date < '2019-03-12 00:00:00'::timestamp without time zone))
41. 0.126 0.126 ↑ 1.0 1 6

Index Scan using entity_aggregated_data_03_entity_id_date_idx on entity_aggregated_data_03 entityaggr0__3 (cost=0.43..3.49 rows=1 width=126) (actual time=0.020..0.021 rows=1 loops=6)

  • Index Cond: ((entity_id = entity1_.id) AND (date >= '2019-03-11 00:00:00'::timestamp without time zone) AND (date < '2019-03-12 00:00:00'::timestamp without time zone))
42. 0.084 0.084 ↑ 1.0 1 2

Index Scan using entity_aggregated_data_04_entity_id_date_idx on entity_aggregated_data_04 entityaggr0__4 (cost=0.43..3.48 rows=1 width=126) (actual time=0.041..0.042 rows=1 loops=2)

  • Index Cond: ((entity_id = entity1_.id) AND (date >= '2019-03-11 00:00:00'::timestamp without time zone) AND (date < '2019-03-12 00:00:00'::timestamp without time zone))
43. 0.054 0.054 ↑ 1.0 1 1

Index Scan using entity_aggregated_data_05_entity_id_date_idx on entity_aggregated_data_05 entityaggr0__5 (cost=0.43..3.49 rows=1 width=126) (actual time=0.053..0.054 rows=1 loops=1)

  • Index Cond: ((entity_id = entity1_.id) AND (date >= '2019-03-11 00:00:00'::timestamp without time zone) AND (date < '2019-03-12 00:00:00'::timestamp without time zone))
44. 0.155 0.155 ↑ 1.0 1 5

Index Scan using entity_aggregated_data_06_entity_id_date_idx on entity_aggregated_data_06 entityaggr0__6 (cost=0.43..3.48 rows=1 width=126) (actual time=0.030..0.031 rows=1 loops=5)

  • Index Cond: ((entity_id = entity1_.id) AND (date >= '2019-03-11 00:00:00'::timestamp without time zone) AND (date < '2019-03-12 00:00:00'::timestamp without time zone))
45. 0.000 0.000 ↓ 0.0 0

Index Scan using entity_aggregated_data_07_entity_id_date_idx on entity_aggregated_data_07 entityaggr0__7 (cost=0.43..3.48 rows=1 width=126) (never executed)

  • Index Cond: ((entity_id = entity1_.id) AND (date >= '2019-03-11 00:00:00'::timestamp without time zone) AND (date < '2019-03-12 00:00:00'::timestamp without time zone))
46. 0.040 0.040 ↑ 1.0 1 1

Index Scan using entity_aggregated_data_08_entity_id_date_idx on entity_aggregated_data_08 entityaggr0__8 (cost=0.43..3.48 rows=1 width=126) (actual time=0.039..0.040 rows=1 loops=1)

  • Index Cond: ((entity_id = entity1_.id) AND (date >= '2019-03-11 00:00:00'::timestamp without time zone) AND (date < '2019-03-12 00:00:00'::timestamp without time zone))
47. 0.081 0.081 ↑ 1.0 1 3

Index Scan using entity_aggregated_data_09_entity_id_date_idx on entity_aggregated_data_09 entityaggr0__9 (cost=0.43..3.49 rows=1 width=126) (actual time=0.026..0.027 rows=1 loops=3)

  • Index Cond: ((entity_id = entity1_.id) AND (date >= '2019-03-11 00:00:00'::timestamp without time zone) AND (date < '2019-03-12 00:00:00'::timestamp without time zone))
48. 0.060 0.060 ↑ 1.0 1 1

Index Scan using entity_aggregated_data_10_entity_id_date_idx on entity_aggregated_data_10 entityaggr0__10 (cost=0.43..3.49 rows=1 width=126) (actual time=0.060..0.060 rows=1 loops=1)

  • Index Cond: ((entity_id = entity1_.id) AND (date >= '2019-03-11 00:00:00'::timestamp without time zone) AND (date < '2019-03-12 00:00:00'::timestamp without time zone))
49. 0.096 0.096 ↑ 1.0 1 3

Index Scan using entity_aggregated_data_11_entity_id_date_idx on entity_aggregated_data_11 entityaggr0__11 (cost=0.43..3.48 rows=1 width=126) (actual time=0.031..0.032 rows=1 loops=3)

  • Index Cond: ((entity_id = entity1_.id) AND (date >= '2019-03-11 00:00:00'::timestamp without time zone) AND (date < '2019-03-12 00:00:00'::timestamp without time zone))
50. 0.093 0.093 ↑ 1.0 1 3

Index Scan using entity_aggregated_data_12_entity_id_date_idx on entity_aggregated_data_12 entityaggr0__12 (cost=0.43..3.49 rows=1 width=126) (actual time=0.031..0.031 rows=1 loops=3)

  • Index Cond: ((entity_id = entity1_.id) AND (date >= '2019-03-11 00:00:00'::timestamp without time zone) AND (date < '2019-03-12 00:00:00'::timestamp without time zone))
51. 0.082 0.082 ↑ 1.0 1 2

Index Scan using entity_aggregated_data_13_entity_id_date_idx on entity_aggregated_data_13 entityaggr0__13 (cost=0.43..3.48 rows=1 width=126) (actual time=0.040..0.041 rows=1 loops=2)

  • Index Cond: ((entity_id = entity1_.id) AND (date >= '2019-03-11 00:00:00'::timestamp without time zone) AND (date < '2019-03-12 00:00:00'::timestamp without time zone))
52. 0.066 0.066 ↑ 1.0 1 3

Index Scan using entity_aggregated_data_14_entity_id_date_idx on entity_aggregated_data_14 entityaggr0__14 (cost=0.43..3.49 rows=1 width=126) (actual time=0.021..0.022 rows=1 loops=3)

  • Index Cond: ((entity_id = entity1_.id) AND (date >= '2019-03-11 00:00:00'::timestamp without time zone) AND (date < '2019-03-12 00:00:00'::timestamp without time zone))
53. 0.165 0.165 ↑ 1.0 1 5

Index Scan using entity_aggregated_data_15_entity_id_date_idx on entity_aggregated_data_15 entityaggr0__15 (cost=0.43..3.49 rows=1 width=126) (actual time=0.031..0.033 rows=1 loops=5)

  • Index Cond: ((entity_id = entity1_.id) AND (date >= '2019-03-11 00:00:00'::timestamp without time zone) AND (date < '2019-03-12 00:00:00'::timestamp without time zone))