explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vaNU : test

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 465.101 ↑ 50.0 4 1

GroupAggregate (cost=122,564.9..123,881.59 rows=200 width=40) (actual time=457.672..465.101 rows=4 loops=1)

  • Group Key: hmup_2.hw_module_id
  • Buffers: shared hit=39535 read=302
2. 141.212 490.258 ↑ 1.0 5,934 1

Gather Merge (cost=122,564.9..123,289.24 rows=5,990 width=48) (actual time=456.166..490.258 rows=5,934 loops=1)

  • Workers Planned: 5
  • Workers Launched: 5
  • Buffers: shared hit=112876 read=1580
3. 1.136 349.046 ↑ 1.2 989 6 / 6

Sort (cost=121,564.83..121,567.82 rows=1,198 width=48) (actual time=348.957..349.046 rows=989 loops=6)

  • Sort Key: hmup_2.hw_module_id, hmup_2.record_time
  • Sort Method: quicksort Memory: 161kB
  • Buffers: shared hit=112876 read=1580
4. 0.076 347.910 ↑ 1.2 989 6 / 6

Append (cost=0..121,503.57 rows=1,198 width=48) (actual time=77.009..347.91 rows=989 loops=6)

  • Buffers: shared hit=112706 read=1580
5. 347.833 347.833 ↑ 1.2 989 6 / 6

Seq Scan on hw_module_user_position_2020_02 hmup_2 (cost=0..121,485.9 rows=1,198 width=48) (actual time=77.005..347.833 rows=989 loops=6)

  • Filter: ((hmup_2.deleted IS FALSE) AND (hmup_2.active IS TRUE) AND (hmup_2.record_time >= '2020-02-15 00:33:14.147295+00'::timestamp with time zone) AND (hmup_2.user_id = 1))
  • Buffers: shared hit=112706 read=1580
6. 0.000 0.000 ↓ 0.0 0 1 / 6

Seq Scan on hw_module_user_position_2020_01 hmup_1 (cost=0..11.68 rows=1 width=48) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ((hmup_1.deleted IS FALSE) AND (hmup_1.active IS TRUE) AND (hmup_1.record_time >= '2020-02-15 00:33:14.147295+00'::timestamp with time zone) AND (hmup_1.user_id = 1))
7. 0.000 0.000 ↓ 0.0 0 1 / 6

Seq Scan on hw_module_user_position hmup (cost=0..0 rows=1 width=48) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((hmup.deleted IS FALSE) AND (hmup.active IS TRUE) AND (hmup.record_time >= '2020-02-15 00:33:14.147295+00'::timestamp with time zone) AND (hmup.user_id = 1))
Planning time : 0.497 ms
Execution time : 497.308 ms