explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TlDq

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 13,644.565 ↑ 6.0 1 1

Append (cost=0.00..597,251.58 rows=6 width=462) (actual time=5,504.563..13,644.565 rows=1 loops=1)

  • Buffers: shared hit=15,494 read=554,296
2. 0.004 13,644.553 ↑ 3.0 1 1

Append (cost=0.00..597,249.34 rows=3 width=458) (actual time=5,504.562..13,644.553 rows=1 loops=1)

  • Buffers: shared hit=15,492 read=554,296
3. 13,644.531 13,644.531 ↑ 1.0 1 1

Seq Scan on audit.audit_2019_09_1 (cost=0.00..597,244.75 rows=1 width=461) (actual time=5,504.561..13,644.531 rows=1 loops=1)

  • Output: audit_2019_09_1.id, audit_2019_09_1.event_date, audit_2019_09_1.event_type, audit_2019_09_1.object_id, audit_2019_09_1.user_id, audit_2019_09_1.username, audit_2019_09_1.source_workstation, audit_2019_09_1.context, audit_2019_09_1.creation_date, audit_2019_09_1.hostname, audit_2019_09_1.audit_type_id, audit_2019_09_1.sender_id, audit_2019_09_1.receiver_id, audit_2019_09_1.object_name_id, audit_2019_09_1.object_type_id, audit_2019_09_1.source_application_id, audit_2019_09_1.object_type, audit_2019_09_1.object_name, audit_2019_09_1.source_application
  • Filter: ((audit_2019_09_1.id = '812910e0-f60e-ad63-4d6f-bd3550fbb724'::uuid) AND (audit_2019_09_1.event_date < now()) AND (audit_2019_09_1.event_date > (now() - '31 days'::interval day)))
  • Rows Removed by Filter: 1,120,998
  • Buffers: shared hit=15,488 read=554,296
4. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on audit.audit_2019_09_2 (cost=0.00..1.07 rows=1 width=466) (actual time=0.011..0.011 rows=0 loops=1)

  • Output: audit_2019_09_2.id, audit_2019_09_2.event_date, audit_2019_09_2.event_type, audit_2019_09_2.object_id, audit_2019_09_2.user_id, audit_2019_09_2.username, audit_2019_09_2.source_workstation, audit_2019_09_2.context, audit_2019_09_2.creation_date, audit_2019_09_2.hostname, audit_2019_09_2.audit_type_id, audit_2019_09_2.sender_id, audit_2019_09_2.receiver_id, audit_2019_09_2.object_name_id, audit_2019_09_2.object_type_id, audit_2019_09_2.source_application_id, audit_2019_09_2.object_type, audit_2019_09_2.object_name, audit_2019_09_2.source_application
  • Filter: ((audit_2019_09_2.id = '812910e0-f60e-ad63-4d6f-bd3550fbb724'::uuid) AND (audit_2019_09_2.event_date < now()) AND (audit_2019_09_2.event_date > (now() - '31 days'::interval day)))
  • Rows Removed by Filter: 3
  • Buffers: shared hit=1
5. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on audit.audit_2019_09_3 (cost=0.00..3.50 rows=1 width=448) (actual time=0.007..0.007 rows=0 loops=1)

  • Output: audit_2019_09_3.id, audit_2019_09_3.event_date, audit_2019_09_3.event_type, audit_2019_09_3.object_id, audit_2019_09_3.user_id, audit_2019_09_3.username, audit_2019_09_3.source_workstation, audit_2019_09_3.context, audit_2019_09_3.creation_date, audit_2019_09_3.hostname, audit_2019_09_3.audit_type_id, audit_2019_09_3.sender_id, audit_2019_09_3.receiver_id, audit_2019_09_3.object_name_id, audit_2019_09_3.object_type_id, audit_2019_09_3.source_application_id, audit_2019_09_3.object_type, audit_2019_09_3.object_name, audit_2019_09_3.source_application
  • Filter: ((audit_2019_09_3.id = '812910e0-f60e-ad63-4d6f-bd3550fbb724'::uuid) AND (audit_2019_09_3.event_date < now()) AND (audit_2019_09_3.event_date > (now() - '31 days'::interval day)))
  • Rows Removed by Filter: 20
  • Buffers: shared hit=3
6. 0.001 0.009 ↓ 0.0 0 1

Append (cost=0.00..2.21 rows=2 width=466) (actual time=0.009..0.009 rows=0 loops=1)

  • Buffers: shared hit=2
7. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on audit.audit_2019_10_1 (cost=0.00..1.18 rows=1 width=466) (actual time=0.005..0.005 rows=0 loops=1)

  • Output: audit_2019_10_1.id, audit_2019_10_1.event_date, audit_2019_10_1.event_type, audit_2019_10_1.object_id, audit_2019_10_1.user_id, audit_2019_10_1.username, audit_2019_10_1.source_workstation, audit_2019_10_1.context, audit_2019_10_1.creation_date, audit_2019_10_1.hostname, audit_2019_10_1.audit_type_id, audit_2019_10_1.sender_id, audit_2019_10_1.receiver_id, audit_2019_10_1.object_name_id, audit_2019_10_1.object_type_id, audit_2019_10_1.source_application_id, audit_2019_10_1.object_type, audit_2019_10_1.object_name, audit_2019_10_1.source_application
  • Filter: ((audit_2019_10_1.id = '812910e0-f60e-ad63-4d6f-bd3550fbb724'::uuid) AND (audit_2019_10_1.event_date < now()) AND (audit_2019_10_1.event_date > (now() - '31 days'::interval day)))
  • Rows Removed by Filter: 7
  • Buffers: shared hit=1
8. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on audit.audit_2019_10_2 (cost=0.00..1.02 rows=1 width=466) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: audit_2019_10_2.id, audit_2019_10_2.event_date, audit_2019_10_2.event_type, audit_2019_10_2.object_id, audit_2019_10_2.user_id, audit_2019_10_2.username, audit_2019_10_2.source_workstation, audit_2019_10_2.context, audit_2019_10_2.creation_date, audit_2019_10_2.hostname, audit_2019_10_2.audit_type_id, audit_2019_10_2.sender_id, audit_2019_10_2.receiver_id, audit_2019_10_2.object_name_id, audit_2019_10_2.object_type_id, audit_2019_10_2.source_application_id, audit_2019_10_2.object_type, audit_2019_10_2.object_name, audit_2019_10_2.source_application
  • Filter: ((audit_2019_10_2.id = '812910e0-f60e-ad63-4d6f-bd3550fbb724'::uuid) AND (audit_2019_10_2.event_date < now()) AND (audit_2019_10_2.event_date > (now() - '31 days'::interval day)))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=1
9. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on audit.audit_2019_11 (cost=0.00..0.00 rows=1 width=466) (actual time=0.001..0.001 rows=0 loops=1)

  • Output: audit_2019_11.id, audit_2019_11.event_date, audit_2019_11.event_type, audit_2019_11.object_id, audit_2019_11.user_id, audit_2019_11.username, audit_2019_11.source_workstation, audit_2019_11.context, audit_2019_11.creation_date, audit_2019_11.hostname, audit_2019_11.audit_type_id, audit_2019_11.sender_id, audit_2019_11.receiver_id, audit_2019_11.object_name_id, audit_2019_11.object_type_id, audit_2019_11.source_application_id, audit_2019_11.object_type, audit_2019_11.object_name, audit_2019_11.source_application
  • Filter: ((audit_2019_11.id = '812910e0-f60e-ad63-4d6f-bd3550fbb724'::uuid) AND (audit_2019_11.event_date < now()) AND (audit_2019_11.event_date > (now() - '31 days'::interval day)))
Planning time : 0.641 ms
Execution time : 13,644.610 ms