explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qUTJ

Settings
# exclusive inclusive rows x rows loops node
1. 99.536 404.514 ↓ 1.0 77,603 1

HashAggregate (cost=31,661.57..33,198.69 rows=76,856 width=80) (actual time=380.891..404.514 rows=77,603 loops=1)

  • Group Key: t.id, t.transport_type_id, t.organization_id, t.status_id, t.tariff_type, t.created_at, t.updated_at, ((((r.data -> 0) ->> 'Departure'::text))::timestamp without time zone), t.labels
2. 9.712 304.978 ↓ 1.0 77,603 1

Gather (cost=4,363.46..29,932.31 rows=76,856 width=80) (actual time=104.717..304.978 rows=77,603 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 89.659 295.266 ↑ 1.2 25,868 3 / 3

Hash Join (cost=3,363.46..20,798.38 rows=32,023 width=80) (actual time=101.770..295.266 rows=25,868 loops=3)

  • Hash Cond: (r.order_id = t.id)
4. 104.528 104.528 ↑ 1.2 25,878 3 / 3

Parallel Seq Scan on route r (cost=0.00..17,030.63 rows=32,023 width=623) (actual time=0.022..104.528 rows=25,878 loops=3)

  • Filter: ((((data -> 0) ->> 'PointID'::text))::integer = ANY ('{3337,31249392,77918439,50677385,33935738,45134433,5,31048375,33949580,45089315,14,20,10289611,89099974,44009457,25565607,45074279,45074285,31276267,31545800,3341,8,71904711,37534833,6,9851,3339,16,2,31289745,35633224,23381011,6041,11,9837,24,89099969,15564683,31289741,77918440,77918441,43994469,46242075,33935735,32893134,31289740,62771745,15,8269152,4,9790310,46242072,50661657,32879486,12,31048376,6821844,37534836,19944229,46242073,37534835,68403069,31276270,31289734,31276271,3088539,120065980,31559341,43949531,16932574,33935739,31559332,71904712,37520704,16932573,46242063,46242066,25,74404560,50677383,33935736,68727005,62379851,4746,27,74404559,33935733,46242070,31289737,19,7,31289739,37534832,1,23,18,89099975,74804035,23381010,71904713,33949582,89099978,77566940,72464520,33949581,3455,44009459,46242067,3340,21,16233,71904708,71904710,68727006,28,29570928,33935734,71904709,31289732,89099979,50708850,32879487,37534831,9790308,46257354,32879483,25565605,45074276,9,31559335,54901057,13,5683,16932572,25565606,46242069,74804036,11841881,10,4597,20721486,12124137,31276280,31289738,31559323,23393397,26,31048378,20721485,43964497,33935737,37534834,31262830,22,31222544,3,3338,46242071,45089314,31276281,5209,33234808,31545799,31303216,31048377,89099977,43994470,72464519,5255,25565604,17,45029225,89099973,31559339,3454,31249395,31289742,120062930,31249393,31559342,31559328,31559344}'::integer[]))
  • Rows Removed by Filter: 2,307
5. 58.416 101.079 ↓ 1.0 85,008 3 / 3

Hash (cost=2,302.65..2,302.65 rows=84,865 width=72) (actual time=101.079..101.079 rows=85,008 loops=3)

  • Buckets: 131,072 Batches: 1 Memory Usage: 9,997kB
6. 42.663 42.663 ↓ 1.0 85,008 3 / 3

Seq Scan on order_v2 t (cost=0.00..2,302.65 rows=84,865 width=72) (actual time=0.021..42.663 rows=85,008 loops=3)

Planning time : 0.347 ms
Execution time : 408.015 ms